Description: This is an Excel workbook that contains detailed reviews of the literature that was searched in the course of a study that explored pre-retirement influences on attitudes and decisions regarding retirement. The research study, conducted by Linda Smith Brothers, reviewed sixty papers written since 1990, and summarized their important points under several categories. The workbook contains a description of the specific categories covered and how they are addressed by each of the sixty papers that were reviewed.

Description: This is an Excel 2003 spreadsheet that accompanies the research report entitled 'The Effect of Deflation or High Inflation on the Insurance Industry.' It models scholastically the effects of inflation and deflation.

Description: The Health Section Research Team is pleased to make available the following research study and Excel model that provide a framework for estimating the financial impact of health plan provider network risk. The research was conducted by the Denver office of Milliman, Inc. The Excel workbook allows the user to assess cost implications of aspects of network risk under various assumptions. The assumptions in the workbook can be altered by the user and be applied to test a range of scenarios.

Description: This Excel workbook contains the complete set of tables developed from the Society of Actuaries 2003 Pension Plan Termination and Retirement Study. Separate tabs are included for the Basic Age Table, Basic Service Table, Select & Ultimate Table, Small Plan Age Table, and Small Plan Service Table.

Description: Long Term Care Think Tank: Exploring the possibilities for helping the American public manage the financial burden of long term care. This report shares the output of a 1.5 day structured brainstorming session involving some of the LTC industry’s preeminent thought leaders. Ideas presented here are intended to help transform the delivery, accessibility, and financing of long term care.

Description: Recognizing an opportunity to help serve its members in this age of increased financial oversight, the Health Section of the Society of Actuaries commissioned a series of guides on the use of statistical techniques specifically geared for the work of health actuaries. The first guide in the series titled, 'Statistical Methods for Health Actuaries - IBNR Estimates: An Introduction,' is about the calculation of incurred but not reported [IBNR] health claims reserves. In particular, the guide focuses on the development of confidence intervals around IBNR estimates. This is an Excel workbook created to demonstrate the techniques discussed in the guide.

Description: The American Academy of Actuaries and the Society of Actuaries have joined resources to maintain this Economic Scenario Generators Excel Workbook tool for use in regulatory reserve and capital calculations. Please see the SOA website research pages for further information on this tool and how to use it.

Description: The Preferred Mortality Valuation Table Team prepared this presentation for the June 2008 NAIC LHATF Meeting. The Adobe Acrobat file on the SOA website for experience studies contains the presentation.This Excel workbook is a tool the valuation table team is using to develop values relating to margins for the new valuation mortality table. The purpose of the workbook is to evaluate different margin formulas and valuation tables. Also used for analysis of mortality margins on Valuation Basic Tables.

Description: The American Academy of Actuaries and the Society of Actuaries have joined resources to maintain this Economic Scenario Generators Excel Workbook tool for use in regulatory reserve and capital calculations. Please see the SOA website research pages for further information on this tool and how to use it.